package com.sunny.fetch.pojo;

import java.util.ArrayList;
import java.util.List;

public class FMoneyflowExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public FMoneyflowExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andTidIsNull() {
            addCriterion("tid is null");
            return (Criteria) this;
        }

        public Criteria andTidIsNotNull() {
            addCriterion("tid is not null");
            return (Criteria) this;
        }

        public Criteria andTidEqualTo(Long value) {
            addCriterion("tid =", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotEqualTo(Long value) {
            addCriterion("tid <>", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThan(Long value) {
            addCriterion("tid >", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidGreaterThanOrEqualTo(Long value) {
            addCriterion("tid >=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThan(Long value) {
            addCriterion("tid <", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidLessThanOrEqualTo(Long value) {
            addCriterion("tid <=", value, "tid");
            return (Criteria) this;
        }

        public Criteria andTidIn(List<Long> values) {
            addCriterion("tid in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotIn(List<Long> values) {
            addCriterion("tid not in", values, "tid");
            return (Criteria) this;
        }

        public Criteria andTidBetween(Long value1, Long value2) {
            addCriterion("tid between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andTidNotBetween(Long value1, Long value2) {
            addCriterion("tid not between", value1, value2, "tid");
            return (Criteria) this;
        }

        public Criteria andTsCodeIsNull() {
            addCriterion("ts_code is null");
            return (Criteria) this;
        }

        public Criteria andTsCodeIsNotNull() {
            addCriterion("ts_code is not null");
            return (Criteria) this;
        }

        public Criteria andTsCodeEqualTo(String value) {
            addCriterion("ts_code =", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeNotEqualTo(String value) {
            addCriterion("ts_code <>", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeGreaterThan(String value) {
            addCriterion("ts_code >", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ts_code >=", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeLessThan(String value) {
            addCriterion("ts_code <", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeLessThanOrEqualTo(String value) {
            addCriterion("ts_code <=", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeLike(String value) {
            addCriterion("ts_code like", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeNotLike(String value) {
            addCriterion("ts_code not like", value, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeIn(List<String> values) {
            addCriterion("ts_code in", values, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeNotIn(List<String> values) {
            addCriterion("ts_code not in", values, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeBetween(String value1, String value2) {
            addCriterion("ts_code between", value1, value2, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTsCodeNotBetween(String value1, String value2) {
            addCriterion("ts_code not between", value1, value2, "tsCode");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNull() {
            addCriterion("trade_date is null");
            return (Criteria) this;
        }

        public Criteria andTradeDateIsNotNull() {
            addCriterion("trade_date is not null");
            return (Criteria) this;
        }

        public Criteria andTradeDateEqualTo(String value) {
            addCriterion("trade_date =", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotEqualTo(String value) {
            addCriterion("trade_date <>", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThan(String value) {
            addCriterion("trade_date >", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateGreaterThanOrEqualTo(String value) {
            addCriterion("trade_date >=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThan(String value) {
            addCriterion("trade_date <", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLessThanOrEqualTo(String value) {
            addCriterion("trade_date <=", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateLike(String value) {
            addCriterion("trade_date like", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotLike(String value) {
            addCriterion("trade_date not like", value, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateIn(List<String> values) {
            addCriterion("trade_date in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotIn(List<String> values) {
            addCriterion("trade_date not in", values, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateBetween(String value1, String value2) {
            addCriterion("trade_date between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andTradeDateNotBetween(String value1, String value2) {
            addCriterion("trade_date not between", value1, value2, "tradeDate");
            return (Criteria) this;
        }

        public Criteria andBuySmVolIsNull() {
            addCriterion("buy_sm_vol is null");
            return (Criteria) this;
        }

        public Criteria andBuySmVolIsNotNull() {
            addCriterion("buy_sm_vol is not null");
            return (Criteria) this;
        }

        public Criteria andBuySmVolEqualTo(Integer value) {
            addCriterion("buy_sm_vol =", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolNotEqualTo(Integer value) {
            addCriterion("buy_sm_vol <>", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolGreaterThan(Integer value) {
            addCriterion("buy_sm_vol >", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("buy_sm_vol >=", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolLessThan(Integer value) {
            addCriterion("buy_sm_vol <", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolLessThanOrEqualTo(Integer value) {
            addCriterion("buy_sm_vol <=", value, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolIn(List<Integer> values) {
            addCriterion("buy_sm_vol in", values, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolNotIn(List<Integer> values) {
            addCriterion("buy_sm_vol not in", values, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolBetween(Integer value1, Integer value2) {
            addCriterion("buy_sm_vol between", value1, value2, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmVolNotBetween(Integer value1, Integer value2) {
            addCriterion("buy_sm_vol not between", value1, value2, "buySmVol");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountIsNull() {
            addCriterion("buy_sm_amount is null");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountIsNotNull() {
            addCriterion("buy_sm_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountEqualTo(Float value) {
            addCriterion("buy_sm_amount =", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountNotEqualTo(Float value) {
            addCriterion("buy_sm_amount <>", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountGreaterThan(Float value) {
            addCriterion("buy_sm_amount >", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("buy_sm_amount >=", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountLessThan(Float value) {
            addCriterion("buy_sm_amount <", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountLessThanOrEqualTo(Float value) {
            addCriterion("buy_sm_amount <=", value, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountIn(List<Float> values) {
            addCriterion("buy_sm_amount in", values, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountNotIn(List<Float> values) {
            addCriterion("buy_sm_amount not in", values, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountBetween(Float value1, Float value2) {
            addCriterion("buy_sm_amount between", value1, value2, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andBuySmAmountNotBetween(Float value1, Float value2) {
            addCriterion("buy_sm_amount not between", value1, value2, "buySmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmVolIsNull() {
            addCriterion("sell_sm_vol is null");
            return (Criteria) this;
        }

        public Criteria andSellSmVolIsNotNull() {
            addCriterion("sell_sm_vol is not null");
            return (Criteria) this;
        }

        public Criteria andSellSmVolEqualTo(Integer value) {
            addCriterion("sell_sm_vol =", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolNotEqualTo(Integer value) {
            addCriterion("sell_sm_vol <>", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolGreaterThan(Integer value) {
            addCriterion("sell_sm_vol >", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("sell_sm_vol >=", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolLessThan(Integer value) {
            addCriterion("sell_sm_vol <", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolLessThanOrEqualTo(Integer value) {
            addCriterion("sell_sm_vol <=", value, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolIn(List<Integer> values) {
            addCriterion("sell_sm_vol in", values, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolNotIn(List<Integer> values) {
            addCriterion("sell_sm_vol not in", values, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolBetween(Integer value1, Integer value2) {
            addCriterion("sell_sm_vol between", value1, value2, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmVolNotBetween(Integer value1, Integer value2) {
            addCriterion("sell_sm_vol not between", value1, value2, "sellSmVol");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountIsNull() {
            addCriterion("sell_sm_amount is null");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountIsNotNull() {
            addCriterion("sell_sm_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountEqualTo(Float value) {
            addCriterion("sell_sm_amount =", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountNotEqualTo(Float value) {
            addCriterion("sell_sm_amount <>", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountGreaterThan(Float value) {
            addCriterion("sell_sm_amount >", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("sell_sm_amount >=", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountLessThan(Float value) {
            addCriterion("sell_sm_amount <", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountLessThanOrEqualTo(Float value) {
            addCriterion("sell_sm_amount <=", value, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountIn(List<Float> values) {
            addCriterion("sell_sm_amount in", values, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountNotIn(List<Float> values) {
            addCriterion("sell_sm_amount not in", values, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountBetween(Float value1, Float value2) {
            addCriterion("sell_sm_amount between", value1, value2, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andSellSmAmountNotBetween(Float value1, Float value2) {
            addCriterion("sell_sm_amount not between", value1, value2, "sellSmAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolIsNull() {
            addCriterion("buy_md_vol is null");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolIsNotNull() {
            addCriterion("buy_md_vol is not null");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolEqualTo(Integer value) {
            addCriterion("buy_md_vol =", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolNotEqualTo(Integer value) {
            addCriterion("buy_md_vol <>", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolGreaterThan(Integer value) {
            addCriterion("buy_md_vol >", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("buy_md_vol >=", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolLessThan(Integer value) {
            addCriterion("buy_md_vol <", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolLessThanOrEqualTo(Integer value) {
            addCriterion("buy_md_vol <=", value, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolIn(List<Integer> values) {
            addCriterion("buy_md_vol in", values, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolNotIn(List<Integer> values) {
            addCriterion("buy_md_vol not in", values, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolBetween(Integer value1, Integer value2) {
            addCriterion("buy_md_vol between", value1, value2, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdVolNotBetween(Integer value1, Integer value2) {
            addCriterion("buy_md_vol not between", value1, value2, "buyMdVol");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountIsNull() {
            addCriterion("buy_md_amount is null");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountIsNotNull() {
            addCriterion("buy_md_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountEqualTo(Float value) {
            addCriterion("buy_md_amount =", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountNotEqualTo(Float value) {
            addCriterion("buy_md_amount <>", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountGreaterThan(Float value) {
            addCriterion("buy_md_amount >", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("buy_md_amount >=", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountLessThan(Float value) {
            addCriterion("buy_md_amount <", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountLessThanOrEqualTo(Float value) {
            addCriterion("buy_md_amount <=", value, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountIn(List<Float> values) {
            addCriterion("buy_md_amount in", values, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountNotIn(List<Float> values) {
            addCriterion("buy_md_amount not in", values, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountBetween(Float value1, Float value2) {
            addCriterion("buy_md_amount between", value1, value2, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyMdAmountNotBetween(Float value1, Float value2) {
            addCriterion("buy_md_amount not between", value1, value2, "buyMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdVolIsNull() {
            addCriterion("sell_md_vol is null");
            return (Criteria) this;
        }

        public Criteria andSellMdVolIsNotNull() {
            addCriterion("sell_md_vol is not null");
            return (Criteria) this;
        }

        public Criteria andSellMdVolEqualTo(Integer value) {
            addCriterion("sell_md_vol =", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolNotEqualTo(Integer value) {
            addCriterion("sell_md_vol <>", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolGreaterThan(Integer value) {
            addCriterion("sell_md_vol >", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("sell_md_vol >=", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolLessThan(Integer value) {
            addCriterion("sell_md_vol <", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolLessThanOrEqualTo(Integer value) {
            addCriterion("sell_md_vol <=", value, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolIn(List<Integer> values) {
            addCriterion("sell_md_vol in", values, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolNotIn(List<Integer> values) {
            addCriterion("sell_md_vol not in", values, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolBetween(Integer value1, Integer value2) {
            addCriterion("sell_md_vol between", value1, value2, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdVolNotBetween(Integer value1, Integer value2) {
            addCriterion("sell_md_vol not between", value1, value2, "sellMdVol");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountIsNull() {
            addCriterion("sell_md_amount is null");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountIsNotNull() {
            addCriterion("sell_md_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountEqualTo(Float value) {
            addCriterion("sell_md_amount =", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountNotEqualTo(Float value) {
            addCriterion("sell_md_amount <>", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountGreaterThan(Float value) {
            addCriterion("sell_md_amount >", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("sell_md_amount >=", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountLessThan(Float value) {
            addCriterion("sell_md_amount <", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountLessThanOrEqualTo(Float value) {
            addCriterion("sell_md_amount <=", value, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountIn(List<Float> values) {
            addCriterion("sell_md_amount in", values, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountNotIn(List<Float> values) {
            addCriterion("sell_md_amount not in", values, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountBetween(Float value1, Float value2) {
            addCriterion("sell_md_amount between", value1, value2, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andSellMdAmountNotBetween(Float value1, Float value2) {
            addCriterion("sell_md_amount not between", value1, value2, "sellMdAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolIsNull() {
            addCriterion("buy_lg_vol is null");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolIsNotNull() {
            addCriterion("buy_lg_vol is not null");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolEqualTo(Integer value) {
            addCriterion("buy_lg_vol =", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolNotEqualTo(Integer value) {
            addCriterion("buy_lg_vol <>", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolGreaterThan(Integer value) {
            addCriterion("buy_lg_vol >", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("buy_lg_vol >=", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolLessThan(Integer value) {
            addCriterion("buy_lg_vol <", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolLessThanOrEqualTo(Integer value) {
            addCriterion("buy_lg_vol <=", value, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolIn(List<Integer> values) {
            addCriterion("buy_lg_vol in", values, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolNotIn(List<Integer> values) {
            addCriterion("buy_lg_vol not in", values, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolBetween(Integer value1, Integer value2) {
            addCriterion("buy_lg_vol between", value1, value2, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgVolNotBetween(Integer value1, Integer value2) {
            addCriterion("buy_lg_vol not between", value1, value2, "buyLgVol");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountIsNull() {
            addCriterion("buy_lg_amount is null");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountIsNotNull() {
            addCriterion("buy_lg_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountEqualTo(Float value) {
            addCriterion("buy_lg_amount =", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountNotEqualTo(Float value) {
            addCriterion("buy_lg_amount <>", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountGreaterThan(Float value) {
            addCriterion("buy_lg_amount >", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("buy_lg_amount >=", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountLessThan(Float value) {
            addCriterion("buy_lg_amount <", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountLessThanOrEqualTo(Float value) {
            addCriterion("buy_lg_amount <=", value, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountIn(List<Float> values) {
            addCriterion("buy_lg_amount in", values, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountNotIn(List<Float> values) {
            addCriterion("buy_lg_amount not in", values, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountBetween(Float value1, Float value2) {
            addCriterion("buy_lg_amount between", value1, value2, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyLgAmountNotBetween(Float value1, Float value2) {
            addCriterion("buy_lg_amount not between", value1, value2, "buyLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgVolIsNull() {
            addCriterion("sell_lg_vol is null");
            return (Criteria) this;
        }

        public Criteria andSellLgVolIsNotNull() {
            addCriterion("sell_lg_vol is not null");
            return (Criteria) this;
        }

        public Criteria andSellLgVolEqualTo(Integer value) {
            addCriterion("sell_lg_vol =", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolNotEqualTo(Integer value) {
            addCriterion("sell_lg_vol <>", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolGreaterThan(Integer value) {
            addCriterion("sell_lg_vol >", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("sell_lg_vol >=", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolLessThan(Integer value) {
            addCriterion("sell_lg_vol <", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolLessThanOrEqualTo(Integer value) {
            addCriterion("sell_lg_vol <=", value, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolIn(List<Integer> values) {
            addCriterion("sell_lg_vol in", values, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolNotIn(List<Integer> values) {
            addCriterion("sell_lg_vol not in", values, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolBetween(Integer value1, Integer value2) {
            addCriterion("sell_lg_vol between", value1, value2, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgVolNotBetween(Integer value1, Integer value2) {
            addCriterion("sell_lg_vol not between", value1, value2, "sellLgVol");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountIsNull() {
            addCriterion("sell_lg_amount is null");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountIsNotNull() {
            addCriterion("sell_lg_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountEqualTo(Float value) {
            addCriterion("sell_lg_amount =", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountNotEqualTo(Float value) {
            addCriterion("sell_lg_amount <>", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountGreaterThan(Float value) {
            addCriterion("sell_lg_amount >", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("sell_lg_amount >=", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountLessThan(Float value) {
            addCriterion("sell_lg_amount <", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountLessThanOrEqualTo(Float value) {
            addCriterion("sell_lg_amount <=", value, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountIn(List<Float> values) {
            addCriterion("sell_lg_amount in", values, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountNotIn(List<Float> values) {
            addCriterion("sell_lg_amount not in", values, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountBetween(Float value1, Float value2) {
            addCriterion("sell_lg_amount between", value1, value2, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andSellLgAmountNotBetween(Float value1, Float value2) {
            addCriterion("sell_lg_amount not between", value1, value2, "sellLgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolIsNull() {
            addCriterion("buy_elg_vol is null");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolIsNotNull() {
            addCriterion("buy_elg_vol is not null");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolEqualTo(Integer value) {
            addCriterion("buy_elg_vol =", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolNotEqualTo(Integer value) {
            addCriterion("buy_elg_vol <>", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolGreaterThan(Integer value) {
            addCriterion("buy_elg_vol >", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("buy_elg_vol >=", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolLessThan(Integer value) {
            addCriterion("buy_elg_vol <", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolLessThanOrEqualTo(Integer value) {
            addCriterion("buy_elg_vol <=", value, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolIn(List<Integer> values) {
            addCriterion("buy_elg_vol in", values, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolNotIn(List<Integer> values) {
            addCriterion("buy_elg_vol not in", values, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolBetween(Integer value1, Integer value2) {
            addCriterion("buy_elg_vol between", value1, value2, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgVolNotBetween(Integer value1, Integer value2) {
            addCriterion("buy_elg_vol not between", value1, value2, "buyElgVol");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountIsNull() {
            addCriterion("buy_elg_amount is null");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountIsNotNull() {
            addCriterion("buy_elg_amount is not null");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountEqualTo(Float value) {
            addCriterion("buy_elg_amount =", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountNotEqualTo(Float value) {
            addCriterion("buy_elg_amount <>", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountGreaterThan(Float value) {
            addCriterion("buy_elg_amount >", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("buy_elg_amount >=", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountLessThan(Float value) {
            addCriterion("buy_elg_amount <", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountLessThanOrEqualTo(Float value) {
            addCriterion("buy_elg_amount <=", value, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountIn(List<Float> values) {
            addCriterion("buy_elg_amount in", values, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountNotIn(List<Float> values) {
            addCriterion("buy_elg_amount not in", values, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountBetween(Float value1, Float value2) {
            addCriterion("buy_elg_amount between", value1, value2, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andBuyElgAmountNotBetween(Float value1, Float value2) {
            addCriterion("buy_elg_amount not between", value1, value2, "buyElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgVolIsNull() {
            addCriterion("sell_elg_vol is null");
            return (Criteria) this;
        }

        public Criteria andSellElgVolIsNotNull() {
            addCriterion("sell_elg_vol is not null");
            return (Criteria) this;
        }

        public Criteria andSellElgVolEqualTo(Integer value) {
            addCriterion("sell_elg_vol =", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolNotEqualTo(Integer value) {
            addCriterion("sell_elg_vol <>", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolGreaterThan(Integer value) {
            addCriterion("sell_elg_vol >", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("sell_elg_vol >=", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolLessThan(Integer value) {
            addCriterion("sell_elg_vol <", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolLessThanOrEqualTo(Integer value) {
            addCriterion("sell_elg_vol <=", value, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolIn(List<Integer> values) {
            addCriterion("sell_elg_vol in", values, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolNotIn(List<Integer> values) {
            addCriterion("sell_elg_vol not in", values, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolBetween(Integer value1, Integer value2) {
            addCriterion("sell_elg_vol between", value1, value2, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgVolNotBetween(Integer value1, Integer value2) {
            addCriterion("sell_elg_vol not between", value1, value2, "sellElgVol");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountIsNull() {
            addCriterion("sell_elg_amount is null");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountIsNotNull() {
            addCriterion("sell_elg_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountEqualTo(Float value) {
            addCriterion("sell_elg_amount =", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountNotEqualTo(Float value) {
            addCriterion("sell_elg_amount <>", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountGreaterThan(Float value) {
            addCriterion("sell_elg_amount >", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("sell_elg_amount >=", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountLessThan(Float value) {
            addCriterion("sell_elg_amount <", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountLessThanOrEqualTo(Float value) {
            addCriterion("sell_elg_amount <=", value, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountIn(List<Float> values) {
            addCriterion("sell_elg_amount in", values, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountNotIn(List<Float> values) {
            addCriterion("sell_elg_amount not in", values, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountBetween(Float value1, Float value2) {
            addCriterion("sell_elg_amount between", value1, value2, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andSellElgAmountNotBetween(Float value1, Float value2) {
            addCriterion("sell_elg_amount not between", value1, value2, "sellElgAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfVolIsNull() {
            addCriterion("net_mf_vol is null");
            return (Criteria) this;
        }

        public Criteria andNetMfVolIsNotNull() {
            addCriterion("net_mf_vol is not null");
            return (Criteria) this;
        }

        public Criteria andNetMfVolEqualTo(Integer value) {
            addCriterion("net_mf_vol =", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolNotEqualTo(Integer value) {
            addCriterion("net_mf_vol <>", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolGreaterThan(Integer value) {
            addCriterion("net_mf_vol >", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolGreaterThanOrEqualTo(Integer value) {
            addCriterion("net_mf_vol >=", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolLessThan(Integer value) {
            addCriterion("net_mf_vol <", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolLessThanOrEqualTo(Integer value) {
            addCriterion("net_mf_vol <=", value, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolIn(List<Integer> values) {
            addCriterion("net_mf_vol in", values, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolNotIn(List<Integer> values) {
            addCriterion("net_mf_vol not in", values, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolBetween(Integer value1, Integer value2) {
            addCriterion("net_mf_vol between", value1, value2, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfVolNotBetween(Integer value1, Integer value2) {
            addCriterion("net_mf_vol not between", value1, value2, "netMfVol");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountIsNull() {
            addCriterion("net_mf_amount is null");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountIsNotNull() {
            addCriterion("net_mf_amount is not null");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountEqualTo(Float value) {
            addCriterion("net_mf_amount =", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountNotEqualTo(Float value) {
            addCriterion("net_mf_amount <>", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountGreaterThan(Float value) {
            addCriterion("net_mf_amount >", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountGreaterThanOrEqualTo(Float value) {
            addCriterion("net_mf_amount >=", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountLessThan(Float value) {
            addCriterion("net_mf_amount <", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountLessThanOrEqualTo(Float value) {
            addCriterion("net_mf_amount <=", value, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountIn(List<Float> values) {
            addCriterion("net_mf_amount in", values, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountNotIn(List<Float> values) {
            addCriterion("net_mf_amount not in", values, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountBetween(Float value1, Float value2) {
            addCriterion("net_mf_amount between", value1, value2, "netMfAmount");
            return (Criteria) this;
        }

        public Criteria andNetMfAmountNotBetween(Float value1, Float value2) {
            addCriterion("net_mf_amount not between", value1, value2, "netMfAmount");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}